Data Warehousing and Olap Technology
نویسندگان
چکیده
DATA WAREHOUSING and Online Analytical Processing (OLAP) are essential elements of decision support, which has increasingly become a focus of the database industry. Data Warehouse provides an effective way for the analysis and statistic to the mass data and helps to do the decision making. Many commercial products and services are now available and all of the principal database management system vendors now have offerings in these areas. The paper introduces the data warehouse and the online analysis process with an accent on their new requirements. I describe back end tools for extracting, cleaning and loading data into the data warehouse, tools for metadata management and for managing the warehouse.
منابع مشابه
Data Warehousing, Data Mining, OLAP and OLTP Technologies Are Indispensable Elements to Support Decision-Making Process in Industrial World
This paper provides an overview of Data warehousing, Data Mining, OLAP, OLTP technologies, exploring the features, new applications and the architecture of Data Warehousing and data mining. The data warehouse supports on-line analytical processing (OLAP), the functional and performance requirements of which are quite different from those of the online transaction processing (OLTP) applications ...
متن کاملRole of OLAP Technology in Data Warehousing for Knowledge Discovery
There are a set of noteworthy newfangled concepts and tools developed into a innovative technology that makes it conceivable to occurrence the problem of providing all the key people in the innovativeness with admittance to whatever level of information needed for the inventiveness to endure and flourish in an progressively modest world. The term that has come to characterize this new technolog...
متن کاملData Mining: Concepts and Techniques, 3rd edition
There are a good number of introductory-level textbooks on data warehousing and OLAP technology, including Kimball and Ross [KR02], Imhoff, Galemmo and Geiger [IGG03], Inmon [Inm96], Berson and Smith [BS97], and Thomsen [Tho97]. Chaudhuri and Dayal [CD97] provide a general overview of data warehousing and OLAP technology. A set of research papers on materialized views and data warehouse impleme...
متن کاملFinding an application-appropriate model for XML data warehouses
Decision support systems help the decision making process with the use of OLAP (On-Line Analytical Processing) and data warehouses. These systems allow the analysis of corporate data. As OLAP and data warehousing evolve, more and more complex data is being used. XML (Extensible Markup Language) is a flexible text format allowing the interchange and the representation of complex data. Finding an...
متن کاملData Warehousing, Multi-Dimensional Data Models, and OLAP
Since the advent of information technology, businesses have been collecting vast amounts of data about their daily transactions. For example, a company keeps track of data regarding the sales of its various products at different stores over a period of time. Businesses can gain valuable insights by analyzing this data to spot trends and correlations in the data. Data warehousing, multidimension...
متن کامل